COVID-19 in Italy. Visuals

(alternatively, see results and code together here)

 

Data source: this GitHubi page

Authors and sources mentioned: Editore/Autore del dataset: Dipartimento della Protezione Civile. Categoria ISO 19115: Salute. Dati forniti dal Ministero della Salute.

Regional data files (Dati per Regione):
  • Struttura file giornaliero: dpc-covid19-ita-regioni-yyyymmdd.csv (dpc-covid19-ita-regioni-20200224.csv)
  • File complessivo: dpc-covid19-ita-regioni.csv
  • File ultimi dati (latest): dpc-covid19-ita-regioni-latest.csv

 

Out[4]:

Currently data as of date: 2021-02-14T17:00:00

 

What's in the original dataframe?

Out[5]:

All column names: ['data', 'stato', 'codice_regione', 'denominazione_regione', 'lat', 'long', 'ricoverati_con_sintomi', 'terapia_intensiva', 'totale_ospedalizzati', 'isolamento_domiciliare', 'totale_positivi', 'variazione_totale_positivi', 'nuovi_positivi', 'dimessi_guariti', 'deceduti', 'casi_da_sospetto_diagnostico', 'casi_da_screening', 'totale_casi', 'tamponi', 'casi_testati', 'note', 'ingressi_terapia_intensiva', 'note_test', 'note_casi', 'totale_positivi_test_molecolare', 'totale_positivi_test_antigenico_rapido', 'tamponi_test_molecolare', 'tamponi_test_antigenico_rapido', 'codice_nuts_1', 'codice_nuts_2']

Out[6]:
data stato codice_regione denominazione_regione lat long ricoverati_con_sintomi terapia_intensiva totale_ospedalizzati isolamento_domiciliare ... note ingressi_terapia_intensiva note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2
7492 2021-02-14T17:00:00 ITA 19 Sicilia 38.115697 13.362357 1030 165 1195 33671 ... NaN 5.0 NaN NaN 145744.0 0.0 1630116.0 485565.0 ITG ITG1
7493 2021-02-14T17:00:00 ITA 9 Toscana 43.769231 11.255889 693 130 823 11342 ... NaN 6.0 NaN NaN 143070.0 305.0 2291264.0 166807.0 ITI ITI1
7494 2021-02-14T17:00:00 ITA 10 Umbria 43.106758 12.388247 451 84 535 7631 ... Si fa presente che 25 dei ricoveri NON UTI, so... 6.0 NaN NaN 40959.0 0.0 647762.0 83904.0 ITI ITI2
7495 2021-02-14T17:00:00 ITA 2 Valle d'Aosta 45.737503 7.320149 13 2 15 122 ... NaN 0.0 NaN NaN 7909.0 0.0 71565.0 2220.0 ITC ITC2
7496 2021-02-14T17:00:00 ITA 5 Veneto 45.434905 12.338452 927 113 1040 23774 ... Nei valori riportati per le terapie intensive ... 8.0 NaN NaN 319142.0 2333.0 3891480.0 682364.0 ITH ITH3

5 rows × 30 columns

 

Variable names to English and their explanation

  • HospWithSymptoms : Currently hospitalized patients with symptoms
  • IC : Intensive care
  • HospTotal: Total number of currently hospitalized patients
  • AtHome : Currently at home confinement
  • CurrentlyPositive : Total amount of current positive cases (Hospitalised patients + Home confinement)
  • NewPositives : New amount of positive cases (Actual total amount of current positive cases - total amount of current positive cases of the previous day)
  • TotalCases : Total amount of positive cases
  • NoOfTests : Tests performed
Out[7]:
Date Region Lat Long HospWithSymptoms IC HospTotal AtHome CurrentlyPositive VariationOfPositives ... ingr_ter_intens note_test note_casi totale_positivi_test_molecolare totale_positivi_test_antigenico_rapido tamponi_test_molecolare tamponi_test_antigenico_rapido codice_nuts_1 codice_nuts_2 Pop
Date
2021-02-10 2021-02-10 Veneto 45.434905 12.338452 1062 136 1198 24773 25971 -359 ... 13.0 NaN NaN 316746.0 2061.0 3850177.0 602340.0 ITH ITH3 4879133
2021-02-11 2021-02-11 Veneto 45.434905 12.338452 1029 135 1164 24454 25618 -353 ... 8.0 NaN NaN 317321.0 2194.0 3861592.0 622202.0 ITH ITH3 4879133
2021-02-12 2021-02-12 Veneto 45.434905 12.338452 1002 123 1125 24284 25409 -209 ... 8.0 NaN NaN 318009.0 2262.0 3872924.0 650451.0 ITH ITH3 4879133
2021-02-13 2021-02-13 Veneto 45.434905 12.338452 942 111 1053 23876 24929 -480 ... 7.0 NaN NaN 318698.0 2262.0 3883017.0 673721.0 ITH ITH3 4879133
2021-02-14 2021-02-14 Veneto 45.434905 12.338452 927 113 1040 23774 24814 -115 ... 8.0 NaN NaN 319142.0 2333.0 3891480.0 682364.0 ITH ITH3 4879133

5 rows × 29 columns

 

daily numbers & moving averages (MA)

(double click and click on legend to select one or multiple regions in the graph)

 

All regions together

Molecular test positive rate

Antigene test positive rate